package DocumentProcessing;

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;

import java.io.IOException;

/**
 * Created by doris on 2016/10/26.
 */
public class DocumentProcessingTest {
    public static void main(String[] args) throws IOException, InvalidFormatException {
        DocumentProcessing xls = new DocumentProcessing("document/OriginalDocument/table.xls");
        xls.setCellFromate(3,8,"设置填充","document/OutPutDocument/设置单元格格式.xls");          //修改单元格样式
        xls.mergeCells(2,2,4,4,"合并单元格","document/OutPutDocument/合并单元格.xls");       //合并单元格
        xls.ChangAllAlignment("document/OutPutDocument/改变对齐.xls");      //改变所有单元格对齐为剧中换行
        xls.sum("A1","A10","document/OutPutDocument/公式加法.xls");
        xls.xlsxRead();       //将所有单元格以字符串输出到控制台

    }
}
